From 32446fa4efa949e60f4a987f049339b5642f0fb4 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 22:02:58 +0000 Subject: [PATCH] Remark on COMM_IDS.Study indexing --- db/schemas/codes/indexes/create/comm_ids.m4 | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/db/schemas/codes/indexes/create/comm_ids.m4 b/db/schemas/codes/indexes/create/comm_ids.m4 index 73dc00e..e281197 100644 --- a/db/schemas/codes/indexes/create/comm_ids.m4 +++ b/db/schemas/codes/indexes/create/comm_ids.m4 @@ -26,3 +26,7 @@ CREATE UNIQUE INDEX IF NOT EXISTS comm_ids_commid_uniquenocase ON comm_ids CREATE UNIQUE INDEX IF NOT EXISTS comm_ids_name_uniquenocase ON comm_ids (sdb_case_equivalence(name)); + +-- We are going to pretend that disk is slow and not index Studied, +-- because there just arn't that many rows. + -- 2.34.1